home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 4 / developer source - volume 4.iso / delph / oct95 / mckif107.gif < prev    next >
Graphics Interchange Format  |  1996-07-02  |  25KB  |  462x177  |  4-bit (16 colors)
Labels: text | screenshot | font | number
OCR: SQL Statement Syntax |Description Example INSERT INTO table (col1, col2, ... ) VALUES (val ?, val2, ... ) Inserts new rows INSERT INTO COUNTRY into a table. ( COUNTRY , CURRENCY ) VALUES ("Indonesia', 'Rupiah') UPDATE table Modifies values of UPDATE COUNTRY SET column = value existing rows. SET CURRENCY = Rp WHERE condition WHERE COUNTRY = 'Indonesia" DELETE FROM table Removes rows DELETE FROM COUNTRY WHERE condition from a table. WHERE COUNTRY @ Indonesia'